﻿SELECT
	[id_account] as [PK],
	[id_category] as [CategoryID],
	[name] as [Name],
	[address] as [Address],
	[zipcode] as [Zipcode],
	[city] as [City],
	[country] as [Country],
	[phone_number] as [PhoneNumber],
	[url] as [Url],
	[mail] as [Mail],
	[comment] as [Comment],
	[last_update] as [LastUpdate],
	[Google] as [Google],
	[Google_last_update] as [GoogleLastUpdate],
	[ZohoCRM] as [Zohocrm],
	[ZohoCRM_last_update] as [ZohocrmLastUpdate],
	[from] as [From],
	[Validated] as [Validated]
FROM
	[CRM_Accounts] INNER JOIN [References]
	ON [CRM_Accounts].[id_account] = [References].[id_reference]
WHERE
	[id_account] = ?
